package com.jack.database_exp.mapper;
import com.jack.database_exp.bean.Plan;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface PlanMapper {
    @Options(useGeneratedKeys = true,keyProperty = "PNo")
    @Insert("insert into plan (PDate,WNo) values(#{PDate},#{WNo})")
    public int insertPaln(Plan plan);
    @Select("select * from plan")
    public List<Plan> queryPlans();
    @Select("select * from plan where PNo = #{PNo}")
    public Plan queryPlanById(Integer PNo);
}